ALTER TABLE changenotificationsmessage add programofficer int
GO
ALTER TABLE changenotificationsmessage add regionaldirector int
GO
ALTER TABLE changenotificationsmessage add programassistant int 
GO
ALTER TABLE changenotificationsmessage add regionid int
GO
ALTER TABLE [dbo].[changenotificationsmessage]   ADD  CONSTRAINT [FKcnuserid1] FOREIGN KEY([programofficer])
REFERENCES [dbo].[userinfo] ([id])
GO

ALTER TABLE [dbo].[changenotificationsmessage]   ADD  CONSTRAINT [FKcnuserid2] FOREIGN KEY([regionaldirector])
REFERENCES [dbo].[userinfo] ([id])
GO

ALTER TABLE [dbo].[changenotificationsmessage]   ADD  CONSTRAINT [FKcnuserid3] FOREIGN KEY([programassistant])
REFERENCES [dbo].[userinfo] ([id])
GO

ALTER TABLE [dbo].[changenotificationsmessage]   ADD  CONSTRAINT [FKcnreagionid] FOREIGN KEY([regionid])
REFERENCES [dbo].[region] ([id])
GO